package com.yc.hr.dao;

import java.util.Map;

import scott.util.JdbcTemplate;

public class EmpDao {
	
	public Map<String,Object> selectByEnameAndPwd(String ename, String pwd){
		String sql = "select * from emp where ename=? and pwd=?"
				+ " and job in ('PRESIDENT','MANAGER')";
		return JdbcTemplate.queryOne(sql, ename, pwd);
	}

}
